/**
 * Created by 白雨浓 on 2018/1/24 9:11.
 */

export const template = `SELECT *
FROM \`<%=tableName%>\`
WHERE state != 0
      AND
      \`<%=tableName%>\`.\`<%=sKeyword%>\` LIKE CONCAT('%', #{keyword}, '%')
ORDER BY state DESC, id DESC
LIMIT #{start}, #{size}`;